<?php
/**
 * Created by JetBrains PhpStorm.
 * User: h2a!
 * Date: 23/11/2012
 * Time: 11:22
 * To change this template use File | Settings | File Templates.
 */

    echo '<table border=\"1\">';
    foreach($query as $row) {
        echo '<tr >';
        echo '<td>'.$row->product_id.'</td>';
        echo '<td>'.$row->product_name.'</td>';
        echo '<td>'.$row->product_price_origin.'</td>';
        echo '</tr>';
    }
    echo '</table>';

?>